#coding: utf-8

from pyExcelerator import *

total=0
def get_stock (sheets):
    global total
    i=1
    while True:
        try:
            sheets[0][1][(i,0)]
        except:
            break
        print '%s   %s'%(sheets[0][1][(i,0)].encode('gbk'),sheets[0][1][(i,6)].encode('gbk'))
        total+=1
        if sheets[0][1].get((i,10)):
            print '%d   %s'%(sheets[0][1][(i,10)],sheets[0][1][(i,11)].encode('gbk'))
            total+=1
        i+=1

get_stock(parse_xls('d:/A股列表.xls'.decode('utf-8')))
print total
